Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
ContactPurposeTypeCode (FK)(PK) | A retailer defined code denoting a reason for contacting a Party. | CD_TYP_CNCT_PRPS | Code2 | char(2) | ContactPurposeType(CO_TYP_CNCT_PRPS) |
ContactMethodTypeCode (FK)(PK) | A retailer assigned code denoting a method of contacting a Party. Suggested values include: WorkPhone, HomePhone, WorkFax, HomeFax, Mobile, Pager. | CD_TYP_CNCT_MTH | Code6 | char(6) | ContactMethodType(CO_TYP_CNCT_MTH) |
BuildingID (PK) | Building ID used where there may be more than one building or structure at a site. This is designed to handle multitenant sites like shopping centers, malls and other venues with more than one structure. | ID_BLDNG | IdentityGTIN | integer | |
AddressID (FK) | A unique system allocated identifier for the Address. | ID_ADS | Identity | integer | Address(LO_ADS) |
EmailAddressID (FK) | A unique system assigned identifier for an electronic address for sending messages. | ID_EM_ADS | Identity | integer | EmailAddress(LO_EML_ADS) |
TelephoneID (FK) | A unique system assigned identifier for this Telephone number | ID_PH | Identity | integer | Telephone(LO_PH) |
WebSiteID (FK) | Token ID for a WebSite entity instance. | ID_WB_STE | Identity | integer | WebSite(LO_WB_STE) |
SocialNetworkUserID (FK) | The token ID for a social network user. This is an internal "dumb" unique ID not the user ID appearing in a social network See UserProfileID. | ID_SCL_NTWRK_HNDL | Identity | integer | SocialNetworkHandle(PA_SCL_NTWRK_HNDL) |
SiteID (FK) | Token ID for a Site | ID_STE | Identity | integer | Site(LO_STE) |